﻿<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title></title>
    <script type="text/javascript" src="../../Content/highlighter/scripts/shCore.js"></script>
    <script type="text/javascript" src="../../Content/highlighter/scripts/shBrushJScript.js"></script>
    <script type="text/javascript" src="../../Content/highlighter/scripts/shBrushCSharp.js"></script>
    <script type="text/javascript" src="../../Content/highlighter/scripts/shBrushXml.js"></script>
    <link type="text/css" rel="stylesheet" href="../../Content/highlighter/styles/shCore.css" />
    <link type="text/css" rel="stylesheet" href="../../Content/highlighter/styles/shCoreEclipse.css" />
    <script type="text/javascript">SyntaxHighlighter.all();</script>
</head>
<body>
    <h3>1.找到my.ini</h3>
    <b>此方法仅适用于mysql5.6及以下版本</b>
    <p>
        1.默认是在mysql根目录下<br />
        2.查看MySql5.6服务<br />
        "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe" <br />
        --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56<br />
    </p>
    <h3>1.取消DNS解析</h3>
    <p>
        skip-name-resolve
    </p>
    <h3>2.设置内存占用</h3>
    <pre>
        performance_schema_max_table_instances=200
        table_definition_cache=200
        table_open_cache=128
    </pre>
</body>
</html>